Custom Integration -Team Notifications

Liquid

{% fetchxml LastEmailSentToTeam %}
    <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
        <entity name="contact">
        <attribute name="fullname" />
        <attribute name="tt_clientcode" />
        <attribute name="contactid" />
        <attribute name="tt_lastemailsentustax" />
        <attribute name="tt_lastemailsentuktax" />
        <attribute name="tt_lastemailsenttrusts" />
        <attribute name="tt_lastemailsentriskandassurance" />
        <attribute name="tt_lastemailsentrandd" />
        <attribute name="tt_lastemailsentpayroll" />
        <attribute name="tt_lastemailsentpartnerships" />
        <attribute name="tt_lastemailsentirelandtax" />
        <attribute name="tt_lastemailsentirelandbts" />
        <attribute name="tt_lastemailsentgeneral" />
        <attribute name="tt_lastemailsentfundstax" />
        <attribute name="tt_lastemailsentdigital" />
        <attribute name="tt_lastemailsentcorporatefinance" />
        <attribute name="tt_lastemailsentbusinesstax" />
        <attribute name="tt_lastemailsentbusinessadvisory" />
        <attribute name="tt_lastemailsentaudit" />
        <attribute name="tt_lastemailsentaccounts" />
        <order attribute="fullname" descending="false" />
        <filter type="and">
            <condition attribute="contactid" operator="eq" uitype="contact" value="{{ contact }}" />
        </filter>
        </entity>
    </fetch>
{% endfetchxml %}

{% if LastEmailSentToTeam.results.entities.size == 1 %}
    {% assign lastEmailUSTax = LastEmailSentToTeam.results.entities[0].tt_lastemailsentustax %}
    {% assign lastEmailUKTax = LastEmailSentToTeam.results.entities[0].tt_lastemailsentuktax %}
    {% assign lastEmailTrusts = LastEmailSentToTeam.results.entities[0].tt_lastemailsenttrusts %}
    {% assign lastEmailRiskAndAssurance = LastEmailSentToTeam.results.entities[0].tt_lastemailsentriskandassurance %}
    {% assign lastEmailResearchAndDevelopment = LastEmailSentToTeam.results.entities[0].tt_lastemailsentrandd %}
    {% assign lastEmailPayroll = LastEmailSentToTeam.results.entities[0].tt_lastemailsentpayroll %}
    {% assign lastEmailPartnerships = LastEmailSentToTeam.results.entities[0].tt_lastemailsentpartnerships %}
    {% assign lastEmailIrelandTax = LastEmailSentToTeam.results.entities[0].tt_lastemailsentirelandtax %}
    {% assign lastEmailIrelandBTS = LastEmailSentToTeam.results.entities[0].tt_lastemailsentirelandbts %}
    {% assign lastEmailGeneral = LastEmailSentToTeam.results.entities[0].tt_lastemailsentgeneral %}
    {% assign lastEmailFundsTax = LastEmailSentToTeam.results.entities[0].tt_lastemailsentfundstax %}
    {% assign lastEmailDigital = LastEmailSentToTeam.results.entities[0].tt_lastemailsentdigital %}
    {% assign lastEmailCorporateFinance = LastEmailSentToTeam.results.entities[0].tt_lastemailsentcorporatefinance %}
    {% assign lastEmailBusinessTax = LastEmailSentToTeam.results.entities[0].tt_lastemailsentbusinesstax %}
    {% assign lastEmailBusinessAdvisory = LastEmailSentToTeam.results.entities[0].tt_lastemailsentbusinessadvisory %}
    {% assign lastEmailAudit = LastEmailSentToTeam.results.entities[0].tt_lastemailsentaudit %}
    {% assign lastEmailAccounts = LastEmailSentToTeam.results.entities[0].tt_lastemailsentaccounts %}
    {% assign lastEmailEmploymentTax = LastEmailSentToTeam.results.entities[0].tt_lastemailsentemploymenttax %}
    {% assign lastEmailVirtualFinanceOffice = LastEmailSentToTeam.results.entities[0].tt_lastemailsentvirtualfinanceoffice %}
{% endif %}

JavaScript

<span id="LastEmailSentdetails"></span>

<script>
    var currentDate = new Date();

    var lastEmailUSTax = '{{ lastEmailUSTax }}';
    var lastEmailUKTax = '{{ lastEmailUKTax }}';
    var lastEmailTrusts = '{{ lastEmailTrusts }}';
    var lastEmailRiskAndAssurance = '{{ lastEmailRiskAndAssurance }}';
    var lastEmailResearchAndDevelopment = '{{ lastEmailResearchAndDevelopment }}';
    var lastEmailPayroll = '{{ lastEmailPayroll }}';
    var lastEmailPartnerships = '{{ lastEmailPartnerships }}';
    var lastEmailIrelandTax = '{{ lastEmailIrelandTax }}';
    var lastEmailIrelandBTS = '{{ lastEmailIrelandBTS }}';
    var lastEmailGeneral = '{{ lastEmailGeneral }}';
    var lastEmailFundsTax = '{{ lastEmailFundsTax }}';
    var lastEmailDigital = '{{ lastEmailDigital }}';
    var lastEmailCorporateFinance = '{{ lastEmailCorporateFinance }}';
    var lastEmailBusinessTax = '{{ lastEmailBusinessTax }}';
    var lastEmailBusinessAdvisory = '{{ lastEmailBusinessAdvisory }}';
    var lastEmailAudit = '{{ lastEmailAudit }}';
    var lastEmailAccounts = '{{ lastEmailAccounts }}';
    var lastEmailEmploymentTax = '{{ lastEmailEmploymentTax }}';
    var lastEmailVirtualFinanceOffice = '{{ lastEmailVirtualFinanceOffice }}';
    
    // Add attributes to the <span> element
    $(`span[id='LastEmailSentdetails']`).data('Audit', lastEmailAudit);
    $(`span[id='LastEmailSentdetails']`).data('Accounts', lastEmailAccounts);
    $(`span[id='LastEmailSentdetails']`).data('Business Advisory', lastEmailBusinessAdvisory);
    $(`span[id='LastEmailSentdetails']`).data('Corporate Finance', lastEmailCorporateFinance);
    $(`span[id='LastEmailSentdetails']`).data('Corporation Tax', lastEmailBusinessTax);
    $(`span[id='LastEmailSentdetails']`).data('Digital', lastEmailDigital);
    $(`span[id='LastEmailSentdetails']`).data('Employment Tax', lastEmailEmploymentTax);
    $(`span[id='LastEmailSentdetails']`).data('Funds Tax', lastEmailFundsTax);
    $(`span[id='LastEmailSentdetails']`).data('General Documents', lastEmailGeneral);
    $(`span[id='LastEmailSentdetails']`).data('Ireland Business Tax', lastEmailIrelandBTS);
    $(`span[id='LastEmailSentdetails']`).data('Partnerships', lastEmailPartnerships);
    $(`span[id='LastEmailSentdetails']`).data('Payroll', lastEmailPayroll);
    $(`span[id='LastEmailSentdetails']`).data('Research And Development', lastEmailResearchAndDevelopment);
    $(`span[id='LastEmailSentdetails']`).data('Risk And Assurance', lastEmailRiskAndAssurance);
    $(`span[id='LastEmailSentdetails']`).data('Trusts', lastEmailTrusts);

    $(`span[id='LastEmailSentdetails']`).data('Ireland Tax', lastEmailIrelandTax);
    $(`span[id='LastEmailSentdetails']`).data('UK Tax', lastEmailUKTax);
    $(`span[id='LastEmailSentdetails']`).data('US Tax', lastEmailUSTax);
    $(`span[id='LastEmailSentdetails']`).data('Virtual Finance Office', lastEmailVirtualFinanceOffice);
</script>